UCE and dynamic aggregation

The IEE Universal Calculation Engine supports dynamic aggregation of service point channels. Specifically, the UCE aggregation functions handle dynamic lists of channels and their associated property- and attribute-based arguments in IEE's entity model, all points under a transformer, for a geographic area, by rate class, etc. This feature eliminates the problem of maintaining explicitly predefined service point channels to be aggregated, which is inefficient and prone to error.

With dynamic aggregation, dynamic groups support service point channels and can be used in formulas.

UCE provides a robust, attribute-based, syntax for defining aggregation formulas. To support dynamic aggregation, four existing aggregation functions that process multiple explicitly defined channels have been enhanced to accept a dynamic list of channels. The UCE can handle both dynamic and traditional syntax within a single formula.

The following table shows the syntax description for the four aggregation functions that supports dynamic list of channels. The syntax is similar to the existing aggregation functions (isum, iavg, imax, and imin) but they can take a dynamic group of service point channels. Specify $group followed by a colon, followed by the group ID. Before IEE implemented dynamic aggregation in version 10.0, you would have had to explicitly list out the channels you wanted to aggregate.

Table 1285 Functions

Function	Description
@isum(«grp»)	Takes the service point channels included in a configuration group and returns sum.	Specify the group as $group:ConfigGroupID. Allows exclude conditions.
@iavg(«grp»)	Takes the service point channels included in a configuration group and returns avg.
@imax(«grp»)	Takes the service point channels included in a configuration group and returns max.
@imin(«grp»)	Takes the service point channels included in a configuration group and returns min.

These four functions support exclusion conditions and terminating conditions. Formulas that contain the dynamic syntax also support multiple levels of nesting, just like the traditional syntax does.

Dynamic aggregation functionality is available in multiple IEE areas that utilize UCE formula builder: Named Formula, Formula Channel, and Interactive Graphing.